Release 10.1A: OpenEdge Development:
Basic Database Tools

Dumping table contents

When you dump table data, The Data Dictionary creates a contents file that contains data for each table you specify. This file has a .d extension. The Data Dictionary uses the contents file to load data into your database. The Data Dictionary creates a separate contents file for every table you dump.

See the "Binary dump and load" section for more information about performing a binary dump and load.

To dump table contents:

Access the Data Dictionary tool.
Make sure you are using the database (the source) from which you want to dump the table data.
Choose Admin Dump Data and Definitions Table Contents (.d files) from the menu bar. The Data Dictionary alphabetically lists all the tables defined for your database (hidden tables do not display).
Select the table names whose contents you want to dump. Use the Select Some and Deselect Some buttons to select or deselect groups of tables.
Press GO.

If you selected a single table, the Data Dictionary displays a default name for the file that you can dump your table contents into. This default file name is always the dump name of the table definition file, with a .d extension. If you want to specify a file name other than the default file, type the name in the Output File field.

If you selected more than one table, the Data Dictionary prompts you for a directory name to write the contents files. If you do not specify a directory, the Data Dictionary creates the files in the current directory. The Data Dictionary names each contents file with the table’s corresponding dump name.

Accept the default or enter a different name.
If you want to use character mapping, enter the character mapping, then choose OK. See the OpenEdge Development: Internationalizing Applications for information about character mapping, PROTERMCAP, and national language support.
Specify the code page or accept the default.

The Data Dictionary displays each table name as it writes the table contents to the table contents file. After dumping the table contents, The Data Dictionary displays a status message. Choose OK to return to the Data Dictionary window.

Choose OK to dump the data contents file(s) and return to the Data Dictionary main window.
Note: You must dump your sequence values separately.

To dump user table contents:

Access the Data Dictionary tool.
Make sure you are using the database from which you want to dump the table data.
Choose Admin Dump Data and Definitions User Table Contents. The Data Dictionary prompts you for the file to which to write the user file contents. The default filename is _user.d.
Specify the filename or accept the default. After dumping the user file contents to the specified file, the Data Dictionary displays a status message and prompts you to continue.
Choose OK to return to the Data Dictionary main window.